In [ ]:
import sqlite3
import pandas as pd
import pygwalker as pyg
# Database file path
db_file_path = "spend_intake2.db"
# Connect to the SQLite database
conn = sqlite3.connect(db_file_path)
# SQL query
query = """
SELECT *
FROM AP_Items_for_classification
"""
# Execute the query and fetch the data into a pandas DataFrame
df = pd.read_sql_query(query, conn)
# Close the database connection
conn.close()
# Use Pygwalker to render the DataFrame
pyg.walk(df, kernel_computation=True, spec='gw_config.json', spec_io_mode="rw")
Box(children=(HTML(value='\n<div id="ifr-pyg-00061fd3fbfe0cbc8WgjJesAac7Fxvul" style="height: auto">\n <hea…
Loading Graphic-Walker UI...